Example: SQL Update

The dataset will be modified to contain the updated fields used in the SET and WHERE update query.

Initial dataset:

Configuration:

SQL SET clause: [Field2] = 10

SQL WHERE clause: [Row Number] <= 3

Resulting dataset:

Related topics:

• Overview of operation: SQL update

• Configuring operation: SQL update

• Overview of operations

• Technical comparison of operations

• Overview of icons